package com.glsc.ngateway.common.base.domain.mysql.opmanage.report.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import com.fasterxml.jackson.annotation.JsonInclude;


import javax.persistence.*;
import java.util.Date;

@Entity
@Table(name = "t_subhk_fund_pnltrdlv")
@JsonInclude(JsonInclude.Include.NON_NULL)
@JsonIgnoreProperties({"hibernateLazyInitializer", "handler"})
@IdClass(PnLTrdLvId.class)
public class PnLTrdLv {
    @Id
    @Column(name="Ticket")
    @ExcelProperty("Ticket")
    private Integer ticket;

    @Column(name="PF")
    @ExcelProperty("PF")
    private String pf;

    @Id
    @Column(name="InputDt")
    @ExcelProperty("InputDt")
    private Date inputDt;

    @Id
    @Column(name="TrdDt")
    @ExcelProperty("TrdDt")
    private Date trdDt;

    @Id
    @Column(name="SettDt")
    @ExcelProperty("SettDt")
    private Date settDt;

    @Column(name="BS")
    @ExcelProperty("BS")
    private String bs;

    @Column(name="InstrType")
    @ExcelProperty("InstrType")
    private String instrType;

    @Column(name="InstrName")
    @ExcelProperty("InstrName")
    private String instrName;

    @Column(name="ISIN")
    @ExcelProperty("ISIN")
    private String isin;

    @Column(name="ExpiryDt")
    @ExcelProperty(value = "ExpiryDt")
    private Date expiryDt;

    @Column(name="IsExpiry")
    @ExcelProperty("IsExpiry")
    private String isExpiry;

    @Column(name="TrdCcy")
    @ExcelProperty("TrdCcy")
    private String trdCcy;

    @Column(name="Qty")
    @ExcelProperty("Qty")
    private Double qty;

    @Column(name="QtyOSBal")
    @ExcelProperty("QtyOSBal")
    private Double qtyOSBal;

    @Column(name="Price")
    @ExcelProperty("Price")
    private Double price;

    @Column(name="Clr_Amt")
    @ExcelProperty(value = "Clr_Amt")
    private Double clr_Amt;

    @Column(name="Ttl_Qty")
    @ExcelProperty("Ttl_Qty")
    private Double ttl_Qty;

    @Column(name="Ttl_Clr_Amt")
    @ExcelProperty("Ttl_Clr_Amt")
    private Double ttl_Clr_Amt;

    @Column(name="OpAvgCostRPL")
    @ExcelProperty("OpAvgCostRPL")
    private Double opAvgCostRPL;

    @Column(name="OpAvgCostUPL")
    @ExcelProperty("OpAvgCostUPL")
    private Double opAvgCostUPL;

    @Column(name="LastYrEndedClsPx")
    @ExcelProperty("LastYrEndedClsPx")
    private Double lastYrEndedClsPx;

    @Column(name="LastMthEndedClsPx")
    @ExcelProperty("LastMthEndedClsPx")
    private Double lastMthEndedClsPx;

    @Column(name="YestClsPx")
    @ExcelProperty("YestClsPx")
    private Double yestClsPx;

    @Column(name="ClsPx")
    @ExcelProperty("ClsPx")
    private Double clsPx;

    @Column(name="`LatestClsPx%`")
    @ExcelProperty("LatestClsPx%")
    private Double latestClsPx;

    @Column(name="TPL")
    @ExcelProperty("TPL")
    private Double tpl;

    @Column(name="UPL")
    @ExcelProperty("UPL")
    private Double upl;

    @Column(name="RPL")
    @ExcelProperty("RPL")
    private Double rpl;

    @Column(name="Carry")
    @ExcelProperty("Carry")
    private Double carry;

    @Column(name="YTPL")
    @ExcelProperty("YTPL")
    private Double ytpl;

    @Column(name="YUPL")
    @ExcelProperty("YUPL")
    private Double yupl;

    @Column(name="YRPL")
    @ExcelProperty("YRPL")
    private Double yrpl;

    @Column(name="YCarry")
    @ExcelProperty("YCarry")
    private Double yCarry;

    @Column(name="MTPL")
    @ExcelProperty("MTPL")
    private Double mtpl;

    @Column(name="MUPL")
    @ExcelProperty("MUPL")
    private Double mupl;

    @Column(name="`MRPL`")
    @ExcelProperty("MRPL")
    private Double mrpl;

    @Column(name="`MCarry`")
    @ExcelProperty("MCarry")
    private Double mCarry;

    @Column(name="DTPL")
    @ExcelProperty("DTPL")
    private Double dtpl;

    @Column(name="DUPL")
    @ExcelProperty("DUPL")
    private Double dupl;

    @Column(name="DRPL")
    @ExcelProperty("DRPL")
    private Double drpl;

    @Column(name="DCarry")
    @ExcelProperty("DCarry")
    private Double dCarry;

    @Column(name="DayCount")
    @ExcelProperty("DayCount")
    private String dayCount;

    @Column(name="CpnRate")
    @ExcelProperty("CpnRate")
    private Double cpnRate;

    @Column(name="StartDay")
    @ExcelProperty("StartDay")
    private Date startDay;

    @Column(name="EndDay")
    @ExcelProperty("EndDay")
    private Date endDay;

    @Column(name="NoOfDay")
    @ExcelProperty("NoOfDay")
    private Integer noOfDay;

    @Column(name="YTDStartDay")
    @ExcelProperty("YTDStartDay")
    private Date ytdStartDay;

    @Column(name="YTDEndDay")
    @ExcelProperty("YTDEndDay")
    private Date ytdEndDay;

    @Column(name="YTDNoOfDay")
    @ExcelProperty("YTDNoOfDay")
    private Integer ytdNoOfDay;

    @Column(name="MTDStartDay")
    @ExcelProperty("MTDStartDay")
    private Date mtdStartDay;

    @Column(name="MTDEndDay")
    @ExcelProperty("MTDEndDay")
    private Date mtdEndDay;

    @Column(name="MTDNoOfDay")
    @ExcelProperty("MTDNoOfDay")
    private Integer mtdNoOfDay;

    @Column(name="BaseYear")
    @ExcelProperty("BaseYear")
    private Integer baseYear;

    @Column(name="IsDateBackTrd")
    @ExcelProperty("IsDateBackTrd")
    private String isDateBackTrd;

    @Column(name="NoOfDateBackDay")
    @ExcelProperty("NoOfDateBackDay")
    private Integer noOfDateBackDay;

    @Column(name="TicketType")
    @ExcelProperty("TicketType")
    private String ticketType;

    @Column(name="RptDt")
    @ExcelProperty("RptDt")
    private Date rptDt;

//    @Column(name="fl_fundid")
//    @ExcelProperty("fundId")
//    private Integer fundId;

    @Id
    @Column(name="fd_date")
    private Date date;

    @Id
    @Column(name="fc_fundname")
    private String fundname;

    public Integer getTicket() {
        return ticket;
    }

    public void setTicket(Integer ticket) {
        this.ticket = ticket;
    }

    public String getPf() {
        return pf;
    }

    public void setPf(String pf) {
        this.pf = pf;
    }

    public Date getInputDt() {
        return inputDt;
    }

    public void setInputDt(Date inputDt) {
        this.inputDt = inputDt;
    }

    public Date getTrdDt() {
        return trdDt;
    }

    public void setTrdDt(Date trdDt) {
        this.trdDt = trdDt;
    }

    public Date getSettDt() {
        return settDt;
    }

    public void setSettDt(Date settDt) {
        this.settDt = settDt;
    }

    public String getBs() {
        return bs;
    }

    public void setBs(String bs) {
        this.bs = bs;
    }

    public String getInstrType() {
        return instrType;
    }

    public void setInstrType(String instrType) {
        this.instrType = instrType;
    }

    public String getInstrName() {
        return instrName;
    }

    public void setInstrName(String instrName) {
        this.instrName = instrName;
    }

    public String getIsin() {
        return isin;
    }

    public void setIsin(String isin) {
        this.isin = isin;
    }

    public Date getExpiryDt() {
        return expiryDt;
    }

    public void setExpiryDt(Date expiryDt) {
        this.expiryDt = expiryDt;
    }

    public String getIsExpiry() {
        return isExpiry;
    }

    public void setIsExpiry(String isExpiry) {
        this.isExpiry = isExpiry;
    }

    public String getTrdCcy() {
        return trdCcy;
    }

    public void setTrdCcy(String trdCcy) {
        this.trdCcy = trdCcy;
    }

    public Double getQty() {
        return qty;
    }

    public void setQty(Double qty) {
        this.qty = qty;
    }

    public Double getQtyOSBal() {
        return qtyOSBal;
    }

    public void setQtyOSBal(Double qtyOSBal) {
        this.qtyOSBal = qtyOSBal;
    }

    public Double getPrice() {
        return price;
    }

    public void setPrice(Double price) {
        this.price = price;
    }

    public Double getClr_Amt() {
        return clr_Amt;
    }

    public void setClr_Amt(Double clr_Amt) {
        this.clr_Amt = clr_Amt;
    }

    public Double getTtl_Qty() {
        return ttl_Qty;
    }

    public void setTtl_Qty(Double ttl_Qty) {
        this.ttl_Qty = ttl_Qty;
    }

    public Double getTtl_Clr_Amt() {
        return ttl_Clr_Amt;
    }

    public void setTtl_Clr_Amt(Double ttl_Clr_Amt) {
        this.ttl_Clr_Amt = ttl_Clr_Amt;
    }

    public Double getOpAvgCostRPL() {
        return opAvgCostRPL;
    }

    public void setOpAvgCostRPL(Double opAvgCostRPL) {
        this.opAvgCostRPL = opAvgCostRPL;
    }

    public Double getOpAvgCostUPL() {
        return opAvgCostUPL;
    }

    public void setOpAvgCostUPL(Double opAvgCostUPL) {
        this.opAvgCostUPL = opAvgCostUPL;
    }

    public Double getLastYrEndedClsPx() {
        return lastYrEndedClsPx;
    }

    public void setLastYrEndedClsPx(Double lastYrEndedClsPx) {
        this.lastYrEndedClsPx = lastYrEndedClsPx;
    }

    public Double getLastMthEndedClsPx() {
        return lastMthEndedClsPx;
    }

    public void setLastMthEndedClsPx(Double lastMthEndedClsPx) {
        this.lastMthEndedClsPx = lastMthEndedClsPx;
    }

    public Double getYestClsPx() {
        return yestClsPx;
    }

    public void setYestClsPx(Double yestClsPx) {
        this.yestClsPx = yestClsPx;
    }

    public Double getClsPx() {
        return clsPx;
    }

    public void setClsPx(Double clsPx) {
        this.clsPx = clsPx;
    }

    public Double getLatestClsPx() {
        return latestClsPx;
    }

    public void setLatestClsPx(Double latestClsPx) {
        this.latestClsPx = latestClsPx;
    }

    public Double getTpl() {
        return tpl;
    }

    public void setTpl(Double tpl) {
        this.tpl = tpl;
    }

    public Double getUpl() {
        return upl;
    }

    public void setUpl(Double upl) {
        this.upl = upl;
    }

    public Double getRpl() {
        return rpl;
    }

    public void setRpl(Double rpl) {
        this.rpl = rpl;
    }

    public Double getCarry() {
        return carry;
    }

    public void setCarry(Double carry) {
        this.carry = carry;
    }

    public Double getYtpl() {
        return ytpl;
    }

    public void setYtpl(Double ytpl) {
        this.ytpl = ytpl;
    }

    public Double getYupl() {
        return yupl;
    }

    public void setYupl(Double yupl) {
        this.yupl = yupl;
    }

    public Double getYrpl() {
        return yrpl;
    }

    public void setYrpl(Double yrpl) {
        this.yrpl = yrpl;
    }

    public Double getyCarry() {
        return yCarry;
    }

    public void setyCarry(Double yCarry) {
        this.yCarry = yCarry;
    }

    public Double getMtpl() {
        return mtpl;
    }

    public void setMtpl(Double mtpl) {
        this.mtpl = mtpl;
    }

    public Double getMupl() {
        return mupl;
    }

    public void setMupl(Double mupl) {
        this.mupl = mupl;
    }

    public Double getMrpl() {
        return mrpl;
    }

    public void setMrpl(Double mrpl) {
        this.mrpl = mrpl;
    }

    public Double getmCarry() {
        return mCarry;
    }

    public void setmCarry(Double mCarry) {
        this.mCarry = mCarry;
    }

    public Double getDtpl() {
        return dtpl;
    }

    public void setDtpl(Double dtpl) {
        this.dtpl = dtpl;
    }

    public Double getDupl() {
        return dupl;
    }

    public void setDupl(Double dupl) {
        this.dupl = dupl;
    }

    public Double getDrpl() {
        return drpl;
    }

    public void setDrpl(Double drpl) {
        this.drpl = drpl;
    }

    public Double getdCarry() {
        return dCarry;
    }

    public void setdCarry(Double dCarry) {
        this.dCarry = dCarry;
    }

    public String getDayCount() {
        return dayCount;
    }

    public void setDayCount(String dayCount) {
        this.dayCount = dayCount;
    }

    public Double getCpnRate() {
        return cpnRate;
    }

    public void setCpnRate(Double cpnRate) {
        this.cpnRate = cpnRate;
    }

    public Date getStartDay() {
        return startDay;
    }

    public void setStartDay(Date startDay) {
        this.startDay = startDay;
    }

    public Date getEndDay() {
        return endDay;
    }

    public void setEndDay(Date endDay) {
        this.endDay = endDay;
    }

    public Integer getNoOfDay() {
        return noOfDay;
    }

    public void setNoOfDay(Integer noOfDay) {
        this.noOfDay = noOfDay;
    }

    public Date getYtdStartDay() {
        return ytdStartDay;
    }

    public void setYtdStartDay(Date ytdStartDay) {
        this.ytdStartDay = ytdStartDay;
    }

    public void setYtdEndDay(Date ytdEndDay) {
        this.ytdEndDay = ytdEndDay;
    }

    public Date getYtdEndDay() {
        return ytdEndDay;
    }

    public Integer getYtdNoOfDay() {
        return ytdNoOfDay;
    }

    public void setYtdNoOfDay(Integer ytdNoOfDay) {
        this.ytdNoOfDay = ytdNoOfDay;
    }

    public Date getMtdEndDay() {
        return mtdEndDay;
    }

    public void setMtdEndDay(Date mtdEndDay) {
        this.mtdEndDay = mtdEndDay;
    }

    public Date getMtdStartDay() {
        return mtdStartDay;
    }

    public void setMtdStartDay(Date mtdStartDay) {
        this.mtdStartDay = mtdStartDay;
    }

    public Integer getMtdNoOfDay() {
        return mtdNoOfDay;
    }

    public void setMtdNoOfDay(Integer mtdNoOfDay) {
        this.mtdNoOfDay = mtdNoOfDay;
    }

    public Integer getBaseYear() {
        return baseYear;
    }

    public void setBaseYear(Integer baseYear) {
        this.baseYear = baseYear;
    }

    public String getIsDateBackTrd() {
        return isDateBackTrd;
    }

    public void setIsDateBackTrd(String isDateBackTrd) {
        this.isDateBackTrd = isDateBackTrd;
    }

    public Integer getNoOfDateBackDay() {
        return noOfDateBackDay;
    }

    public void setNoOfDateBackDay(Integer noOfDateBackDay) {
        this.noOfDateBackDay = noOfDateBackDay;
    }

    public String getTicketType() {
        return ticketType;
    }

    public void setTicketType(String ticketType) {
        this.ticketType = ticketType;
    }

    public Date getRptDt() {
        return rptDt;
    }

    public void setRptDt(Date rptDt) {
        this.rptDt = rptDt;
    }

//    public Integer getFundId() {
//        return fundId;
//    }
//
//    public void setFundId(Integer fundId) {
//        this.fundId = fundId;
//    }

    public String getFundName() {
        return fundname;
    }

    public void setFundName(String fundname) {
        this.fundname = fundname;
    }

    public void setDate(Date date) {
        this.date = date;
    }

    public Date getDate() {
        return date;
    }
}


